--Generate PasswordSalt 
Select CONVERT(VARBINARY, NEWID()) FOR XML PATH('')

USE [FBMembership_2]
GO

select * from aspnet_Applications

DECLARE	@return_value int,
		@UserId uniqueidentifier

EXEC	@return_value = [dbo].[aspnet_Membership_CreateUser]
		@ApplicationName = N'/',
		@UserName = N'yy02.wang',
		@Password = N'abc@123',
		@PasswordSalt = N'Mployi528kulEx7GTWgfmg==',
		@Email = N'yy02.wang@fcjrjt.com',
		@PasswordQuestion = NULL,
		@PasswordAnswer = NULL,
		@IsApproved = 1,
		@CurrentTimeUtc = N'2013-11-26',
		@UserId = @UserId OUTPUT

SELECT	@UserId as N'@UserId'

SELECT	'Return Value' = @return_value

GO

-- change password format to hashed format
--update fbmembership_2.dbo.aspnet_membership set passwordformat=1 where passwordformat=0